UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gUTvZJpliTDNjeGzigw997thipScD+vMfafoNFMh24c='
WHERE
key_id = '71c3df2fa770c555c8ed13d5c2c048df4070caf6997dcefa709a6f8e1d6b2b8f'
AND (
token = 'gUTvZJpliTDNjeGzigw997thipScD+vMfafoNFMh24c='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)