UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7cr7UFDvmlNZIxAnQDbonZXyuTaC1ZEWwHrt/api8nI='
WHERE
key_id = '3e95fd2a901f12a81a32c636cb91d828b0663a237680f9561c0c160c93174b7a'
AND (
token = '7cr7UFDvmlNZIxAnQDbonZXyuTaC1ZEWwHrt/api8nI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)