UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3u1soI9uSrOZy78WZC4FfUt/f2Fx8I9xT15j6CGuMxc='
WHERE
key_id = 'd52ef1507561599715f4e5e027f0037f769b68d14f8d4551e327be8d5fb72ca9'
AND (
token = '3u1soI9uSrOZy78WZC4FfUt/f2Fx8I9xT15j6CGuMxc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)