UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'AfD8EZeOUpE0iHgnCHlqiaZxqYB4v5hl0rklc7q2Nvk='
WHERE
key_id = 'a2798a96184265701529e9d3e1a82b1caec9812620086d53443b3a4bcc7a7fe0'
AND (
token = 'AfD8EZeOUpE0iHgnCHlqiaZxqYB4v5hl0rklc7q2Nvk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)