UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xP6wiQww6weYTlnmpTI+Dz924ZCPp6kBekUWjLG+a9o='
WHERE
key_id = '3a7fa0022d7e600fd4508861c71d78359ad7575a140f7ffe4c4fefb5a7ac828f'
AND (
token = 'xP6wiQww6weYTlnmpTI+Dz924ZCPp6kBekUWjLG+a9o='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)