UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xo5mKGhdtoobw3LWuyu7PCw77YJC4S1xQcEZxgV+t4I='
WHERE
key_id = '7df479371ca0fcb8476c01c58fe600c468418451c67de7707435551b3085fd12'
AND (
token = 'xo5mKGhdtoobw3LWuyu7PCw77YJC4S1xQcEZxgV+t4I='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)