UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '+uRpkuCbSO3ePfooFhSO8QTTfmvkOsrvkZv8ZwY0Igs='
WHERE
key_id = 'b7ffb49bc53d62b8d97ace0455045ff48e40986f4d2e267c4799402227409756'
AND (
token = '+uRpkuCbSO3ePfooFhSO8QTTfmvkOsrvkZv8ZwY0Igs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)