UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'YGmB8UOgb6zdShYMikDuhzZKmCum2qZv6Kw54UPMPBU='
WHERE
key_id = '5ae431d878559cfdb92bf1a90653cfe511294756e3bb41c22d3be2864b009d3e'
AND (
token = 'YGmB8UOgb6zdShYMikDuhzZKmCum2qZv6Kw54UPMPBU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)