UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'RShQq1PQ5R1w7B9fOcGwjYTE0FFPzOgVwuDC1uANIFE='
WHERE
key_id = '9cd76cde51d9a24f30892e801d25534f0b4c57ff24bee6ea174d0aba186a9280'
AND (
token = 'RShQq1PQ5R1w7B9fOcGwjYTE0FFPzOgVwuDC1uANIFE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)