UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zDEa7BXKlYU+phHmhe5yziuTWGUui5nPvK2VZ3zV3lQ='
WHERE
key_id = '5916076cfc2da10cc57819ef24c6ea4135211781e611ac1659bccd023fb5f401'
AND (
token = 'zDEa7BXKlYU+phHmhe5yziuTWGUui5nPvK2VZ3zV3lQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)