UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tICpG04vtHkGGgaY4vuXXIBOfDXasop4nIb++TGtDQ4='
WHERE
key_id = '0d006f333d3b7d3201b4376379065bd05c5ea20ae7933d895786c70e10a8a640'
AND (
token = 'tICpG04vtHkGGgaY4vuXXIBOfDXasop4nIb++TGtDQ4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)