UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pzSz1bwo06+eS9D2N2Es/2QeTspQ7Kgk3l3Ik76qqSk='
WHERE
key_id = '467d79f5bc463c6d33988161b0f6adb2007cc6ab89ad2893aa8617a670cb5877'
AND (
token = 'pzSz1bwo06+eS9D2N2Es/2QeTspQ7Kgk3l3Ik76qqSk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)