UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'J2VM47JPVOAxVeO2yR4aFxdOzVvaHxn8PRgLZ59k+0I='
WHERE
key_id = 'e89dd6a371160bcae4dc7eab49adae3161eb67c7f8d9901d866ba0b4b08d0d0e'
AND (
token = 'J2VM47JPVOAxVeO2yR4aFxdOzVvaHxn8PRgLZ59k+0I='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)