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