UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bCohDGo/uqn5YnmlgkandHbaBZZEDNI4X0lYC+P7IvI='
WHERE
key_id = 'b83c47870cb39d0b78fb41261e85e760bf3105fc77e327846d3499d7063b92fd'
AND (
token = 'bCohDGo/uqn5YnmlgkandHbaBZZEDNI4X0lYC+P7IvI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)