UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hzJbiBZA8ZjRryjr/YsWvHXQEPcCicrk1kRBTbh6aFY='
WHERE
key_id = 'a7f48d6420be70d14f5b9a74ab13e23ea26cbe92b97a1be9414322d6d657e40f'
AND (
token = 'hzJbiBZA8ZjRryjr/YsWvHXQEPcCicrk1kRBTbh6aFY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)