UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lKwiog2ccJtrbnLVM7MBuz4Kd13Y0wGZ800zWnCmfns='
WHERE
key_id = '99db45f521fcf3b059072f91e81614de4de86a49842046c450167563331182fc'
AND (
token = 'lKwiog2ccJtrbnLVM7MBuz4Kd13Y0wGZ800zWnCmfns='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)