UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1hqPoZWlJxOVbf1qoKTjUud5n7plIo1y/5rGwLuV72c='
WHERE
key_id = 'ec9c78013f1ceff6d9b6370e46b3a7961eb987fe3538ddf0c42f298091cf5533'
AND (
token = '1hqPoZWlJxOVbf1qoKTjUud5n7plIo1y/5rGwLuV72c='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)