UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'kfoVKF1szUR46v3KXE+cADhQp83Gfd9pR3x70SOMhMs='
WHERE
key_id = '46e4852bc124771e51c921c6555e4e324c55b105b7bad3b05298afec3da5ae08'
AND (
token = 'kfoVKF1szUR46v3KXE+cADhQp83Gfd9pR3x70SOMhMs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)