UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'eBN/nb6K7gIg5yEoIp1jJrQBcEi5UUkjsC7M8XZ7Hc0='
WHERE
key_id = '7e8f18f5aa9a6a9f4c993073bf30bfe12230be1499fb8d7d7a1aa01a0a926a43'
AND (
token = 'eBN/nb6K7gIg5yEoIp1jJrQBcEi5UUkjsC7M8XZ7Hc0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)