UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'X9Rd0YGHvOtGvNklB72d+WC02zG4uqS/RzCwlb0kXko='
WHERE
key_id = '0cbc796730cd8455e9a210bfad4b294a691fbc3855ef26325f8f1305f81f94d2'
AND (
token = 'X9Rd0YGHvOtGvNklB72d+WC02zG4uqS/RzCwlb0kXko='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)