UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vCfDsZ4oIA2SiCoNU0yl3bB9rubAfXkzISkyuYh0Xr8='
WHERE
key_id = 'bc2e64c4e8b1e7e19a5250501eea89c7c18b0ebdfa05369198006cf7857e2dc7'
AND (
token = 'vCfDsZ4oIA2SiCoNU0yl3bB9rubAfXkzISkyuYh0Xr8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)