UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VSCUb2Vw+XeeEBHNXH9xtm5dxSOjeg+c+TgufXA9jME='
WHERE
key_id = '3af4c24d4be3cea58b7b248bae340adb219d7b2dec008efb7425e15f90d4c6a6'
AND (
token = 'VSCUb2Vw+XeeEBHNXH9xtm5dxSOjeg+c+TgufXA9jME='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)