UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xJfQTMXij2M8W32js7NZNsE2dlzaYL2iUJp0CopTTl4='
WHERE
key_id = '9447aa4c52de35451eee0d7d5b5123eabd5e608ca998b6d127782a7ec6779423'
AND (
token = 'xJfQTMXij2M8W32js7NZNsE2dlzaYL2iUJp0CopTTl4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)