UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gKQy3YzG42ZY3Oyyd1cDCSikYR6UkMerwj9DtW3ChU0='
WHERE
key_id = '3114013a02d11a6cb610fa1edd4fd60e8f234f804dd4b11d700952aebbbb2f3a'
AND (
token = 'gKQy3YzG42ZY3Oyyd1cDCSikYR6UkMerwj9DtW3ChU0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)