UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'LqhaSH0FvKRaTP3qjBbn9Otscj/qrvFH4pOeFwjAsmA='
WHERE
key_id = '4ca856d518f20954458dd372649a7d43f71648bc871c017b901be2a4d5ed4255'
AND (
token = 'LqhaSH0FvKRaTP3qjBbn9Otscj/qrvFH4pOeFwjAsmA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)