UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5uLSWYgsRwPHDlwojQxim3z7KwVTpRs7gCznWdEWQsE='
WHERE
key_id = 'd307022390e7ee5def2008b84b3069b82065cba3a0c7b1b79f58cd109c46fec2'
AND (
token = '5uLSWYgsRwPHDlwojQxim3z7KwVTpRs7gCznWdEWQsE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)